package com.burger.counter.Constants;

public interface SQLConstants {

	String getUser = "SELECT userid, password, regionid,FirstName,LastName,ZipCode,DateOfBirth FROM counterburger.user where email=?";
	String getRegion = "SELECT DISTINCT regionid, regionname FROM counterburger.region";	
	String getBurgerInBun = "SELECT burgerid, burgername,burgerweight,burgerprice,burgertype FROM counterburger.burger where regionid=? and burgertype = 'Bun' order by burgername";
	//String updateBurgerInBunCount="update counterburger.burger  set BurgerCount=? where RegionId=? and BurgerName=? and BurgerType=? and BurgerWeight=?";	
	String getBurgerInBowl = "SELECT burgerid, burgername,burgerweight,burgerprice,burgertype FROM counterburger.burger where regionid=? and burgertype = 'Bowl' order by burgername";	
	String distinctBurgerName = "SELECT DISTINCT burgername FROM counterburger.burger where regionid=? and (burgertype = 'Bun' || burgertype = 'Bowl')";	
	String cheeseListWithoutPrice = "SELECT DISTINCT cheeseid,cheesename FROM counterburger.cheese where regionid=?";
	String cheeseListWithPrice = "SELECT DISTINCT cheeseid, cheesename,cheeseextraprice FROM counterburger.cheese where regionid=?";
	String toppingListWithoutPrice = "SELECT DISTINCT toppingid, toppingname FROM counterburger.topping where regionid=?";
	String toppingListWithPrice = "SELECT toppingid, toppingname,toppingextraprice FROM counterburger.topping where regionid=?";
	String premiumToppingList = "SELECT premiumtoppingid, premiumtoppingname,premiumtoppingprice FROM counterburger.premiumtopping where regionid=?"; //Updated by Anu
	String sauceListWithoutPrice = "SELECT sauceid, saucename FROM counterburger.sauce where regionid=?";
	String sauceListWithPrice = "SELECT sauceId,saucename,sauceextraprice FROM counterburger.sauce where regionid=?";
	String getStarter = "SELECT starterId,startername, starterprice, starterdesc FROM counterburger.starter where regionid=?";	
	String getDessert = "SELECT dessertid, dessertname, dessertprice, dessertdesc FROM counterburger.dessert where regionid=?";	
	String getBeverage = "SELECT beverageid,beveragename, beverageprice FROM counterburger.beverage where regionid=?";	
	String getKids = "SELECT kidsid, kidsname, kidsdesc, kidsprice FROM counterburger.kids where regionid=?";			
	String getSignatureBurgerBun = "SELECT sigburgerbunid,sigburgerbunname, sigburgerbundesc, sigburgerbunprice FROM counterburger.signatureburgerbun where regionid = ?";
	String getSignatureBurgerBowl = "SELECT sigburgerbowlid, sigburgerbowlname, sigburgerbowldesc, sigburgerbowlprice FROM counterburger.signatureburgerbowl where regionid = ?";
	String getFountain = "SELECT fountainid, fountainname, fountainprice, fountaindesc FROM counterburger.fountain where regionid=?";
	String getSandwich = "SELECT sandwichid,sandwichname, sandwichprice, sandwichdesc FROM counterburger.sandwich where regionid=?";
	String getEntree = "SELECT  entreeid, entreename, entreedesc, entreeprice FROM counterburger.entree where regionid=?";	
	
	
	/******************** SHWETA ****************************/
	String updateKidsCount = "UPDATE counterburger.Kids SET KidsCount=KidsCount+1 where regionid=? and KidsName like ? ";
	String updateFountainCount = "UPDATE counterburger.Fountain SET FountainCount=FountainCount+1 where regionid=? and FountainName like ? ";
	String updateEntreeCount = "UPDATE counterburger.Entree SET EntreeCount=EntreeCount+1 where regionid=? and EntreeName like ? ";
	String updateCheeseCount = "UPDATE counterburger.Cheese SET CheeseCount=CheeseCount+1 where regionid=? and CheeseName like ? ";
    String updateBurgerCount = "UPDATE counterburger.Burger SET Burgercount = Burgercount + 1 where regionid = ? and Burgertype = ? and Burgerweight = ? and BurgerName like ? ";
	
	/******************** SHWETA ****************************/

	/******************** ANU ****************************/
	
	String getRegionAndTax = "SELECT DISTINCT regionname, tax FROM counterburger.region";
	String getTax = "SELECT DISTINCT tax FROM counterburger.region where RegionId=?";
	String getTaxDetails = "SELECT DISTINCT regionname, tax FROM counterburger.region where RegionId=?";
	String insertUserDetails = "INSERT into counterburger.USER(firstname,lastname,email,zipcode,dateofbirth,regionid,password,isadminorcustomer) VALUES(?,?,?,?,?,?,?,?)";
	String updateUserDetails = "UPDATE counterburger.USER SET firstname =?,lastname =?,zipcode =?,dateofbirth =?,regionid =?,password = ?,isadminorcustomer = ? WHERE Email= ? and UserId = ?;";
	String updateDessertCount = "UPDATE counterburger.dessert SET dessertcount=dessertcount+1 where regionid=? and dessertname like ?";
	String updatePremiumToppingCount = "UPDATE counterburger.premiumtopping SET premiumtoppingcount=premiumtoppingcount+1 where regionid=? and premiumtoppingname like ?";
	String updateSauceCount = "UPDATE counterburger.sauce SET saucecount=saucecount+1 where regionid=? and saucename like ?";
	String updateToppingCount = "UPDATE counterburger.topping SET toppingcount=toppingcount+1 where regionid=? and toppingname like ?";
	String checkDuplicateEmailId = "SELECT email FROM counterburger.user where email = ?";	
	String updateUserFirstName = "UPDATE counterburger.user SET firstname=? where email=?";
	String updateUserLastName = "UPDATE counterburger.user set lastname=? where email=?";
	String updateUserZipcode = "UPDATE counterburger.user set zipcode=? where email=?";
	String updateUserDateOfBirth = "UPDATE counterburger.user set dateofbirth=? where email=?";
	String updateUserRegionId = "UPDATE counterburger.user set regionid=? where email=?";
	String updateUserPassword = "UPDATE counterburger.user set password=? where email=?";
	String maxOrderIdFromOrder = "SELECT ifnull(max(orderid),1) from counterburger.order";
	String insertIntoOrder = "INSERT into counterburger.ORDER(orderid,userid,regionid,orderdate,price,quantity,itemid,orderpickupdate) VALUES(?,?,?,?,?,?,?,?)";
	String getOrderDetails = "SELECT orderid, userid, regionid, orderdate, price, quantity, itemid, orderpickupdate FROM counterburger.order where userid = ?";

	/******************** ANU ****************************/
	
	
	/******************** Deepali ****************************/

	String getBun = "SELECT bunId,BunName FROM counterburger.bun b where regionid=?";
	String updateBunCount = "UPDATE counterburger.Bun SET BunCount=BunCount+1 where regionid=? and BunName like ? ";
	String updateBeverageCount = "UPDATE counterburger.Beverage SET BeverageCount=BeverageCount+1 where regionid=? and BeverageName like ? ";
	String updateSandwichCount = "UPDATE counterburger.Sandwich SET SandwichCount=SandwichCount+1 where regionid=? and SandwichName like ? ";
	String updateStarterCount = "UPDATE counterburger.starter SET StarterCount=StarterCount+1 where regionid=? and starterName like ?";	
	String updateSignatureBurgerBowlCount = "UPDATE counterburger.SignatureBurgerBowl SET SigBurgerBowlCount=SigBurgerBowlCount+1 where regionid=? and SigBurgerBowlName like ?";
	String updateSignatureBurgerBunCount = "UPDATE counterburger.SignatureBurgerBun SET SigBurgerBunCount=SigBurgerBunCount+1 where regionid=? and SigBurgerBunName like ?";

	/******************** Deepali ****************************/



	
}
